[2020-09-09 10:09:27:965] [DEBUG] [method:org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:327)]
Returning JDBC Connection to DataSource

[2020-09-09 10:09:27:966] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.getSqlSession(SqlSessionUtils.java:99)]
Creating a new SqlSession

[2020-09-09 10:09:27:966] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.registerSessionHolder(SqlSessionUtils.java:150)]
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1f1a149b] was not registered for synchronization because synchronization is not active

[2020-09-09 10:09:27:966] [DEBUG] [method:org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110)]
Fetching JDBC Connection from DataSource

[2020-09-09 10:09:27:978] [DEBUG] [method:org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:89)]
JDBC Connection [jdbc:mysql://127.0.0.1:3306/kettle?useUnicode=true&characterEncoding=utf-8&useSSL=false, UserName=root@localhost, MySQL Connector Java] will not be managed by Spring

[2020-09-09 10:09:27:978] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
==>  Preparing: select r.NAME as name, r.WEB_APP_NAME as webappName, r.MASTER as master, r.ID_SLAVE as slaveId, r.HOST_NAME as hostName, r.`PORT` as port, r.USERNAME as username, r.PASSWORD as password from r_slave r WHERE 1=1 

[2020-09-09 10:09:27:978] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
==> Parameters: 

[2020-09-09 10:09:27:979] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
<==      Total: 0

[2020-09-09 10:09:27:979] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.closeSqlSession(SqlSessionUtils.java:193)]
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1f1a149b]

[2020-09-09 10:09:27:980] [DEBUG] [method:org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:327)]
Returning JDBC Connection to DataSource

[2020-09-09 10:09:27:980] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.getSqlSession(SqlSessionUtils.java:99)]
Creating a new SqlSession

[2020-09-09 10:09:27:980] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.registerSessionHolder(SqlSessionUtils.java:150)]
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6144d249] was not registered for synchronization because synchronization is not active

[2020-09-09 10:09:27:980] [DEBUG] [method:org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110)]
Fetching JDBC Connection from DataSource

[2020-09-09 10:09:27:981] [DEBUG] [method:org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:89)]
JDBC Connection [jdbc:mysql://127.0.0.1:3306/kettle?useUnicode=true&characterEncoding=utf-8&useSSL=false, UserName=root@localhost, MySQL Connector Java] will not be managed by Spring

[2020-09-09 10:09:27:982] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
==>  Preparing: select j.name as name, j.ID_DIRECTORY as directoryId, j.ID_TRANSFORMATION as transformationId from r_transformation j WHERE 1=1 AND j.`NAME` IN ( select DISTINCT TASK_NAME from d_task_group_member_attribute where TASK_GROUP_NAME in ( select TASK_GROUP_NAME from d_user_group_tasks_relation where USER_GROUP_NAME=? ) AND TYPE="trans" ) 

[2020-09-09 10:09:27:982] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
==> Parameters: Pristin(String)

[2020-09-09 10:09:27:983] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
<==      Total: 3

[2020-09-09 10:09:27:983] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.closeSqlSession(SqlSessionUtils.java:193)]
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6144d249]

[2020-09-09 10:09:27:983] [DEBUG] [method:org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:327)]
Returning JDBC Connection to DataSource

[2020-09-09 10:09:27:983] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.getSqlSession(SqlSessionUtils.java:99)]
Creating a new SqlSession

[2020-09-09 10:09:27:984] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.registerSessionHolder(SqlSessionUtils.java:150)]
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@71304905] was not registered for synchronization because synchronization is not active

[2020-09-09 10:09:27:984] [DEBUG] [method:org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110)]
Fetching JDBC Connection from DataSource

[2020-09-09 10:09:27:985] [DEBUG] [method:org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:89)]
JDBC Connection [jdbc:mysql://127.0.0.1:3306/kettle?useUnicode=true&characterEncoding=utf-8&useSSL=false, UserName=root@localhost, MySQL Connector Java] will not be managed by Spring

[2020-09-09 10:09:27:985] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
==>  Preparing: select r.NAME as name, r.WEB_APP_NAME as webappName, r.MASTER as master, r.ID_SLAVE as slaveId, r.HOST_NAME as hostName, r.`PORT` as port, r.USERNAME as username, r.PASSWORD as password from r_slave r WHERE 1=1 

[2020-09-09 10:09:27:986] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
==> Parameters: 

[2020-09-09 10:09:27:986] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
<==      Total: 0

[2020-09-09 10:09:27:987] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.closeSqlSession(SqlSessionUtils.java:193)]
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@71304905]

[2020-09-09 10:09:27:987] [DEBUG] [method:org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:327)]
Returning JDBC Connection to DataSource

[2020-09-09 10:09:27:987] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.getSqlSession(SqlSessionUtils.java:99)]
Creating a new SqlSession

[2020-09-09 10:09:27:987] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.registerSessionHolder(SqlSessionUtils.java:150)]
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3efbf7a5] was not registered for synchronization because synchronization is not active

[2020-09-09 10:09:27:987] [DEBUG] [method:org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110)]
Fetching JDBC Connection from DataSource

[2020-09-09 10:09:27:988] [DEBUG] [method:org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:89)]
JDBC Connection [jdbc:mysql://127.0.0.1:3306/kettle?useUnicode=true&characterEncoding=utf-8&useSSL=false, UserName=root@localhost, MySQL Connector Java] will not be managed by Spring

[2020-09-09 10:09:27:989] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
==>  Preparing: select r.NAME as name, r.WEB_APP_NAME as webappName, r.MASTER as master, r.ID_SLAVE as slaveId, r.HOST_NAME as hostName, r.`PORT` as port, r.USERNAME as username, r.PASSWORD as password from r_slave r WHERE 1=1 

[2020-09-09 10:09:27:989] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
==> Parameters: 

[2020-09-09 10:09:27:990] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
<==      Total: 0

[2020-09-09 10:09:27:990] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.closeSqlSession(SqlSessionUtils.java:193)]
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3efbf7a5]

[2020-09-09 10:09:27:991] [DEBUG] [method:org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:327)]
Returning JDBC Connection to DataSource

[2020-09-09 10:09:27:991] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.getSqlSession(SqlSessionUtils.java:99)]
Creating a new SqlSession

[2020-09-09 10:09:27:991] [DEBUG] [method:org.mybatis.spring.SqlSessionUtils.registerSessionHolder(SqlSessionUtils.java:150)]
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@55792070] was not registered for synchronization because synchronization is not active

[2020-09-09 10:09:27:991] [DEBUG] [method:org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110)]
Fetching JDBC Connection from DataSource

[2020-09-09 10:09:27:992] [DEBUG] [method:org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:89)]
JDBC Connection [jdbc:mysql://127.0.0.1:3306/kettle?useUnicode=true&characterEncoding=utf-8&useSSL=false, UserName=root@localhost, MySQL Connector Java] will not be managed by Spring

[2020-09-09 10:09:27:992] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
==>  Preparing: select d.ID_JOBTASK as idJobtask, d.ID_JOB as idJob, d.JOB_NAME as jobName, d.SLAVES as slaves, d.ISREPEAT as isrepeat, d.SCHEDULERTYPE as schedulertype, d.INTERVALMINUTES as intervalminutes, d.`HOUR` as hour, d.MINUTES as minutes, d.WEEKDAY as weekday, d.DAYOFMONTH as dayofmonth, d.executionConfig as executionConfig, d.username as username from d_timerscheduler d WHERE 1=1 and d.JOB_NAME IN ( select TASK_NAME from d_task_group_member_attribute WHERE TASK_GROUP_NAME IN ( select TASK_GROUP_NAME from d_user_group_tasks_relation WHERE USER_GROUP_NAME=? ) and type="job" ) 

[2020-09-09 10:09:27:993] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
==> Parameters: Pristin(String)

[2020-09-09 10:09:27:994] [DEBUG] [method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:145)]
<==      Total: 1

